The Data Source Type field will open a drop-down list of the available types as listed earlier. In case of Excel and Access the Data Source is the actual file with a full path that is selected by clicking the ellipse button. Once the path is provided, it is suggested to pick Test Connection to ensure that the source is set up correctly. For Data Source Type ODBC, OLEDB, SQL and Oracle connections, additional information, which includes such items as login information, is required in a dialog as shown below:

The Advanced button opens a dialog that allows to adopt delimiters used in SQL statements. For the well-defined data source types (Excel, Access, Oracle) the values are preconfigured. Generic data source types may need modifications.